I have been tasked with converting some scripts referencing an Informix database to be compatible with a new Oracle database.
I thought I would start out by going through the individual scripts and looking for function calls that may vary syntactically between Informix and Oracle. I had been able to find the Oracle equivalent for most of the function calls I came across, however this one has me a little stumped:
where f.writetime > current - interval(xxx) day to day
What exactly does that function mean, particularly the (xxx) part and what is the Oracle equivalent?